Dataset contains 8,760 rows and 36 columns (after dropping attributes)
Key column categories:
- Station info: STATION, DATE, LATITUDE, LONGITUDE, ELEVATION, NAME
- Weather variables: Cloud, DewPoint, Pressure, Temperature, Wind| Pittsburgh Hourly Weather Observations (1981–2010) | |||||
| Cloud (% Clear) | DewPoint (°F) | Pressure (hPa) | Temperature (°F) | Wind (MPH) | |
|---|---|---|---|---|---|
| count | 8760.0 | 8760.0 | 8760.0 | 8760.0 | 8760.0 |
| mean | 13.12 | 40.57 | 1017.74 | 51.57 | 8.09 |
| std | 8.77 | 14.91 | 1.66 | 16.39 | 2.29 |
| min | 0.7 | 17.6 | 1014.1 | 23.8 | 3.4 |
| 25% | 6.3 | 25.9 | 1016.3 | 36.1 | 6.3 |
| 50% | 10.8 | 39.0 | 1018.0 | 51.75 | 8.3 |
| 75% | 18.3 | 56.4 | 1019.1 | 65.5 | 9.7 |
| max | 41.4 | 63.4 | 1021.5 | 81.2 | 13.3 |
| Cloud (Scattered %) | Temperature (°F) | Wind (MPH) | |
|---|---|---|---|
| Month | |||
| 1 | 5.93 | 28.71 | 9.63 |
| 2 | 6.46 | 31.48 | 9.41 |
| 3 | 7.38 | 39.69 | 9.56 |
| 4 | 8.54 | 51.33 | 9.28 |
| 5 | 11.00 | 60.52 | 7.92 |
| 6 | 15.00 | 69.10 | 7.05 |
| 7 | 16.65 | 72.83 | 6.50 |
| 8 | 15.33 | 71.31 | 6.16 |
| 9 | 11.95 | 64.14 | 6.58 |
| 10 | 9.84 | 52.78 | 7.36 |
| 11 | 7.89 | 42.89 | 8.58 |
| 12 | 5.94 | 32.80 | 9.15 |
Findings:
- June-August: temperature rises and wind decreases causing more scattered clouds in the sky.
- September-December: temperature falls and wind picks up, while cloud cover decreases.
- This proves the higher the temperature and slower the wind, the more clouds there are and vice versa.| Season | Spring | Summer | Fall | Winter |
|---|---|---|---|---|
| Pressure_Range_hPa | ||||
| 1014-1015 | 240 | 120 | 0 | 0 |
| 1015-1016 | 811 | 533 | 0 | 0 |
| 1016-1017 | 617 | 750 | 0 | 18 |
| 1017-1018 | 384 | 572 | 141 | 113 |
| 1018-1019 | 156 | 206 | 868 | 665 |
| 1019-1020 | 0 | 27 | 939 | 997 |
| 1020+ | 0 | 0 | 236 | 367 |